<?php
(!defined('IN_TOA') || !defined('IN_ADMIN')) && exit('Access Denied!');
/*
	[天生创想] (C)2008-2011 515158 Inc.
	This is NOT a freeware, use is subject to license terms
    URL:http://www.515158.com/
*/
get_config_keytable("file_");


function get_inc_user_types($fid=0)
{
    global $db;
	$html='';
	$query = $db->query("SELECT title FROM ".DB_TABLEPRE."file_type where id='".$fid."' ORDER BY id desc limit 0,1");
	while ($rowuser = $db->fetch_array($query)) {
	$html .= $rowuser[title];
	}
	return $html;
}



empty($do) && $do = 'list';
if ($do == 'list') {
	//列表信息 
	$wheresql = '';
	$page = max(1, getGP('page','G','int'));
	$pagesize = 20;
	$offset = ($page - 1) * $pagesize;
	$url = 'admin.php?ac=index&fileurl=file';

	if ($keyword = getGP('keyword','G')) {
		$wheresql .= " AND filename LIKE '%$keyword%'";
		$url .= '&keyword='.rawurlencode($keyword);
	}
	//时间
	$vstartdate = getGP('vstartdate','G');
	$venddate = getGP('venddate','G');
	if ($vstartdate!='' && $venddate!='') {
	$wheresql .= " AND (date>='".$vstartdate."' and date<='".$venddate."')";
	$url .= '&vstartdate='.$vstartdate.'&venddate='.$venddate;
	}
	$num = $db->result("SELECT COUNT(*) AS num FROM ".DB_TABLEPRE."file WHERE 1 $wheresql");
     $sql = "SELECT * FROM ".DB_TABLEPRE."file WHERE 1 $wheresql ORDER BY id desc LIMIT $offset, $pagesize";
	$result = $db->fetch_all($sql);

	include_once('template/index.php');

} elseif ($do == '删 除') {
get_config_keytable("file_type_delete");
	
	$idarr = getGP('id','P','array');
	foreach ($idarr as $id) {
	$db->query("DELETE FROM ".DB_TABLEPRE."file WHERE id = '$id'");
	$db->query("DELETE FROM ".DB_TABLEPRE."file_read WHERE fileid= '$id'");
	$content=$id;
	$title='删除档案信息';
	get_oa_log_dbadd($id,$content,$title,20,$_USER->id);	
	}
    goto_page('admin.php?ac=index&fileurl=file');

}
?>